#ifndef DOEXCEL_H
#define DOEXCEL_H
#include <QString>
#include <QList>
#include <QAxObject>

class DoExcel:public QAxObject
{
public:
    DoExcel(QString name="");

    void GetAllData(QList<QList<QVariant>> &alldata);
    QString GetItemData(int row,int clom);
    QStringList GetItemDatas(int row,int clom,int w,int h);

    void SetName(const QString name);
    QString GetName()const;

    void SetSheetIndex(const int index);
    QString GetSheetIndex()const;

private:
    void InstanceExcelObj();

private:
    QAxObject *ExcelObj_ = nullptr;
    QString ExcelName_;
    int SheetIndex_ = 1;
};

#endif // DOEXCEL_H
